Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'd like to protect the macros in a workbook but allow the user to save it as
a different filename. Once I lock the VBAProject I can't save as another name. I'm thinking a solution would be to wrap unprotect and re-protect around the save (if that's possible), but I'm stumped on the code. Please see below... 'I need code to unprotect project here ConNum = TextBox1.Value ActiveWorkbook.SaveAs Filename:="C:\Orders\" & ConNum & ".xls" Application.RecentFiles.Add Name:=ThisWorkbook.FullName 'Also code to protect project here Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to lock project from viewing | Excel Programming | |||
Unlock for Viewing | Excel Worksheet Functions | |||
Unlock VBA Project | Excel Programming | |||
Unlock VBA Project | Excel Discussion (Misc queries) | |||
Unlock VBA project | Excel Programming |