Vital: Protecting sheets so macros/buttons still work?
What are the error codes? Protecting a sheet shouldn't affect the execution
of a macro It may be as simple as the buttons attempting to alter the value
of a protected cell.
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!
|