| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save as the Macro Protected File
Hi,
I have a Excell File which contains a "Locked for Viewing" Macro/Code. I want the a group of users to update the same and send me back where they can use the macro but restricted to view or edit in Macro.... Is this possible? The Code is not digitally signed.. Help me out if is there the solution for the same Thanks Muk |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save as the Macro Protected File
The users should be able to update the worksheets even if the macro is locked
for viewing. Or are you saying that the users should be able to edit the macro code? Muk wrote: Hi, I have a Excell File which contains a "Locked for Viewing" Macro/Code. I want the a group of users to update the same and send me back where they can use the macro but restricted to view or edit in Macro.... Is this possible? The Code is not digitally signed.. Help me out if is there the solution for the same Thanks Muk -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save as the Macro Protected File
Dave,
User is not able to save as different name. Remainning things works fine While saving the file it gives message that you need to unprotect the code and then try to save. "Dave Peterson" wrote: The users should be able to update the worksheets even if the macro is locked for viewing. Or are you saying that the users should be able to edit the macro code? Muk wrote: Hi, I have a Excell File which contains a "Locked for Viewing" Macro/Code. I want the a group of users to update the same and send me back where they can use the macro but restricted to view or edit in Macro.... Is this possible? The Code is not digitally signed.. Help me out if is there the solution for the same Thanks Muk -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save as the Macro Protected File
What version of excel are you using?
And are you trying to save as a normal excel workbook (*.xls) or an earlier version of excel--or some other file format? Muk wrote: Dave, User is not able to save as different name. Remainning things works fine While saving the file it gives message that you need to unprotect the code and then try to save. "Dave Peterson" wrote: The users should be able to update the worksheets even if the macro is locked for viewing. Or are you saying that the users should be able to edit the macro code? Muk wrote: Hi, I have a Excell File which contains a "Locked for Viewing" Macro/Code. I want the a group of users to update the same and send me back where they can use the macro but restricted to view or edit in Macro.... Is this possible? The Code is not digitally signed.. Help me out if is there the solution for the same Thanks Muk -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save editable version of Protected file | Excel Discussion (Misc queries) | |||
| Macro Save File (Unique file name) | Excel Worksheet Functions | |||
| Macro to save a file as | Excel Discussion (Misc queries) | |||
| Macro to save a file as a PDF | Excel Discussion (Misc queries) | |||
| a protected cell w/formula only updates only on file save? | Excel Discussion (Misc queries) | |||
Hybrid Mode
