protecting a workbook but still able to run macros

**jimb0693** · 03-07-2008, 05:10 PM

is it possible to protect a workbook but still run various macros, i have tried this and the macros wont run

**VBA Noob** · 03-07-2008, 05:15 PM

See link

http://www.ozgrid.com/VBA/excel-macr...cted-sheet.htm

VBA Noob

**jimb0693** · 03-24-2008, 03:10 AM

this is the code found at that location, works brilliantly thanks but is the anything i can add in so that the user can still right click and insert comments in the cells

Private Sub Workbook_Open()
Dim wSheet As Worksheet

    For Each wSheet In Worksheets
        wSheet.Protect Password:="Secret", _
            UserInterFaceOnly:=True

Next wSheet

End Sub

**royUK** · 03-24-2008, 03:24 AM

Example workbook here

http://www.excel-it.com/vba_examples.htm

**jimb0693** · 03-24-2008, 07:32 AM

that was almost exactly what i wanted, i still needed to do a bit more research and messing around to get it working right but have now got exactly the workbook result i needed

thank you

**jimb0693** · 06-14-2008, 07:57 AM

is there a way to change the password in this macro, every time i try i get an error message saying i've entered the wrong password. i tried changing the code and putting it in a new workbook and it worked ok, but it wont let me change it in an existing workbook

protecting a workbook but still able to run macros

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

protecting a workbook but still able to run macros

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions