ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "Lock project for viewing" doesn't get saved (https://www.excelbanter.com/excel-programming/433340-lock-project-viewing-doesnt-get-saved.html)

N Selinger

"Lock project for viewing" doesn't get saved
 
When you "Move or Copy" a worksheet to its own file (workbook), the macro
project lock/password does not get passed to the new file (macros in the new
file ARE able to be viewed/edited). Is there a way to programmatically lock
and/or unlock the macro project?

--
N Selinger

ryguy7272

"Lock project for viewing" doesn't get saved
 
Maybe this...
See 'Copy A Module From One Project To Another'
http://www.cpearson.com/excel/vbe.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"N Selinger" wrote:

When you "Move or Copy" a worksheet to its own file (workbook), the macro
project lock/password does not get passed to the new file (macros in the new
file ARE able to be viewed/edited). Is there a way to programmatically lock
and/or unlock the macro project?

--
N Selinger



All times are GMT +1. The time now is 03:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com