+ Reply to Thread
Results 1 to 2 of 2

Changing sheet protection

  1. #1
    Registered User
    Join Date
    07-05-2006
    Posts
    6

    Changing sheet protection

    I made a bit of a bugger up in a file I created. In essence what it was supposed to do was just collect some user information using a form. Enter it onto selected cells in specified sheets and then protect those cells from been altered.

    That works perfectly except for the fact that when I protected the sheets I forgot to allow users to be able to change the rest of the cells regarding things like format etc.

    Now I've already sent this out and I am not keen on telling every single person how to correct it or what the password is.

    Can any possibly suggest the code I would use for a button that would simply do the following:

    Activate a specified workbook
    Unprotect each sheet in that workbook
    Protect each sheet again but allow all cells to be altered in any way except for cells specified as locked previously

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482
    That can easily be done with the macro recorder

+ 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