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

  • Thread starter Thread starter Chris J Denver
  • Start date Start date
C

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
 
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
Click to expand...

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
 
Back
Top