Results 1 to 12 of 12

Thread: protecting the spreadsheet causes xlConn fail

Threaded View

  1. Mar 2nd, 2005, 05:08 AM #1
    Firestart
    Firestart is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 2005
    Posts
    69

    Question protecting the spreadsheet causes xlConn fail

    Hi.

    I need to protect a spreadsheet and protecting the spreadsheet causes the .open of xlConn to fail.

    I need to check the protection status of the spreadsheet in vb and if protection is enabled, disable it, passing it the sheets unprotect password. Should be relatively simple using xlobjects.


    Can anyone help?
    Last edited by Firestart; Mar 7th, 2005 at 09:09 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width