Quote:
Originally Posted by isabelle
hi,
when you protect the sheet, you have to allow the users to edit objects
(DrawingObjects:=False)
ActiveSheet.Protect "password", DrawingObjects:=False, Contents:=True,
Scenarios:=True
isabelle
Le 2014-07-21 11:58, clvrbas a écrit :
This works really great, one problem though; when I protect the sheet it
re sizes to normal size and has an error, is there a way around that?
|
Thank you, i should have specified more clearly. I was hoping I could only allow users to edit that particular object, and not the other objects I have on the sheet. I'll insert this and see what I can do! :) Thank you for your help.
-- Chris