Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default Excel 2007 VBA


"Nick Hodge" wrote

I would say, from my testing yes. To be honest, I've always done that
unprotect, change, protect as these were not available pre XP.

Thanks Nick. I think I can workaround. I put ActiveSheet.Unprotect at the
top of the userform that controls the VBA. I just need to find a way to put
ActiveSheet.Protect in automatically when the userform exits. If you have
any ideas....

Thanks for your advise

TP


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 xlsx files open as Read-Only in Excel 2003 after Compat Tim Excel Discussion (Misc queries) 1 March 31st 07 11:12 AM
Problems with my links to an excel 2007 file from a word 2007 file sc Links and Linking in Excel 0 February 21st 07 10:12 AM
Excel 2007, why is it slow opening files created in Excel 2003? Rick B Excel Discussion (Misc queries) 1 February 19th 07 02:21 AM
Office 2007 Pro Plus 2007 (Beta) - getting small red and green arr Bdhooper1 Excel Discussion (Misc queries) 1 July 19th 06 11:39 PM
Trouble opening large size Excel file 155Mb in Excel 2007 pl2c Excel Discussion (Misc queries) 2 July 14th 06 11:45 PM


All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"