Protecting a sheet and using macro's

  • Thread starter Thread starter dyalikedags
  • Start date Start date
D

dyalikedags

Right…

On SHEET 1 I have some numbers…simple ones.
I also have a button/macro which works out what the sum of thes
numbers is and places the answer in a box on SHEET 2.

If you password protect the second page, the macro doesn’t work. Ho
can I protect the cells on the second page and still make the macr
work
 
protect the sheet with user interface only like this, this must be set each
time the workbook is open so you may want to put in in the workbook open
event

Sheets("Sheet2").Protect UserInterfaceOnly:=True, password:="123"

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Back
Top