+ Reply to Thread
Results 1 to 2 of 2

protecting and unprotecting

  1. #1
    Registered User
    Join Date
    01-22-2010
    Location
    Norway
    MS-Off Ver
    Excel 2007
    Posts
    33

    protecting and unprotecting

    At the moment I get an error when pressing the save as pdf button I've made. I believe this is because it is protected.

    I've got a code that I would like to unprotect right before color change, and protect after pdf is made and color changed back. I've tried a few things, but I'm not really sure what I'm doing.

    I've used before
    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.
    But this doesn't work. Has this got something to do with the (Cancel As Boolean)?

    Anyways:

    Please Login or Register  to view this content.
    Any help would be very helpful. I'm learning slowly, but I seem to be hitting a lot of walls

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: protecting and unprotecting

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1