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?