Results 1 to 5 of 5

Macro to password protect with some editing options

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2011
    Location
    Brisbane, QLD
    MS-Off Ver
    Excel 2002
    Posts
    25

    Macro to password protect with some editing options

    I want to be able to run a macro that password protects a sheet, but I want to allow certain editing options. Current I use

    Sheets("Master Sheet").Protect Password:="secret"
    This allows users to select unlocked cells & select locked cells.

    I would like to allow users the following
    Select locked cells
    Select unlocked cells
    Format rows
    Delete rows

    Is there any way to do this in a macro?

    Thanks
    Last edited by BridgeCat; 05-15-2012 at 10:34 AM.

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