Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
ExcelLock and VBA macros (Read 1778 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
ExcelLock and VBA macros
02.02.11 at 21:37:45
 
ExcelLock and VBA macros
 
Quote:
secure excel 2007 workbooks

Can VBA macros run when the file viewer is unlocked? I need to have clients enter data and run macros via spreadsheet buttons that modify some of the locked and unlocked cells. The macro unlocks and relocks the locked cells. The locked cells that are to be modified do not contain formulas.
Thanks

 
Yes, the macros can still run. It is perfect you place buttons on the sheet to run the macros. The menus are not available in the viewer so you need something like these buttons to start the macros.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1