I have one user who invariably insists on applying a password to everything, even common files; I want to try and stop them from doing so....
On this occasion I'm not "forcing" my users into enabling macro for this particular project - there's no advantage to do so,
Does anybody know of a relatively easy way to ensure the workbook open/saveas password cannot be applied by any users?
When macro are enabled I do it by cancelling the SaveAs event.
Alternatively... what is the VBA required to remove WB open password that has been applied? (that could go into the WB open event)
I've come with up with the possible (untested) solution below, placed in the WB_beforesave event, so that when macro are enabled it stops the password being applied....
(1) kill thisworkbook.fullname
and then
(2) thisworkbook.saveas filename:= thisworkbook.name, password:=""
any thoughts gratefully received, thanks
On this occasion I'm not "forcing" my users into enabling macro for this particular project - there's no advantage to do so,
Does anybody know of a relatively easy way to ensure the workbook open/saveas password cannot be applied by any users?
When macro are enabled I do it by cancelling the SaveAs event.
Alternatively... what is the VBA required to remove WB open password that has been applied? (that could go into the WB open event)
I've come with up with the possible (untested) solution below, placed in the WB_beforesave event, so that when macro are enabled it stops the password being applied....
(1) kill thisworkbook.fullname
and then
(2) thisworkbook.saveas filename:= thisworkbook.name, password:=""
any thoughts gratefully received, thanks