ExcelBanter - View Single Post - Vital: Protecting sheets so macros/buttons still work?

Gary[_18_]

In article ,
says...
Sorry, hit Send prematurely!
Try wrapping your code in

Sheets("Sheet1").Unprotect ("YourPassword")
Your Code
Sheets("Sheet1").Protect ("YourPassword")

I would also suggest using unprotect in the first few lines of the macro
and then protect command in thre last few lines. Thats how I do it on my
sheets

Regards,
"StargateFanFromWork" wrote in message
...
This is a big one, it's become extremely vital. Over last 3 weeks I have
done a lot of work writing up several workbooks that contain numerous
buttons with macros assigned to them. One false step or accidental delete
and those buttons are gone! But when I protect the sheet, all the buttons
return error codes.

Can someone pls direct me to a webpage tutorial that explains how to
protect
sheets so that the buttons will still work? I understand how to lock
cells
and such, that I've been doing for years, it's protecting the sheet as per
normal but allowing the buttons full functionality.

Thank you!