ThisWorkbook.Unprotect ("password") depends on Service Pack??

[Chris J Denver]

Hi newsgroup,

I've got a macro that protects and unprotects the workbook at the
beginning/end of the macro. We've written this for Excel 2007 but have
found this doesn't really work -- well it does sometimes and it
doesn't sometimes, and we think this is due to which Service Pack is
installed on the PC?

We've tried runnning it in lots of different environments and
apparently it works in Windows 7 but in Vista only when Service Pack 2
is installed but not when Service Pack 1 is installed?

Is there anyone who knows about this, and any way to sort this out so
it works all the time? Or is there an alternative function that works
in all environments?

Many thanks,

Chris

 

[GS]

Chris J Denver explained on 4/12/2012 :

Hi newsgroup,

I've got a macro that protects and unprotects the workbook at the
beginning/end of the macro. We've written this for Excel 2007 but have
found this doesn't really work -- well it does sometimes and it
doesn't sometimes, and we think this is due to which Service Pack is
installed on the PC?

We've tried runnning it in lots of different environments and
apparently it works in Windows 7 but in Vista only when Service Pack 2
is installed but not when Service Pack 1 is installed?

Is there anyone who knows about this, and any way to sort this out so
it works all the time? Or is there an alternative function that works
in all environments?

Many thanks,

Chris

Are you certain the issue is not macro security related? What you
describe has nothing to do with OS SPs!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion