| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I write a Macro that
only allows certain users to open a spreadsheet?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I write a Macro that
mydogpeanut wrote:
only allows certain users to open a spreadsheet? Have a look at the application.username property. This can be changed in Tools/Options/General so it is not exactly failsafe. /Sune |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I write a Macro that
Generally speaking macros are easy to defeat in terms of security. Why not
use password protection. File - Save As - Tools - General Options - Password. Now the only wat to open the spreadsheet is with the password. -- HTH... Jim Thomlinson "mydogpeanut" wrote: only allows certain users to open a spreadsheet? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I write a Macro that
Thanks Jim. I did this. It's probably easier than putting a Macro in any way.
Appreciate the help. "Jim Thomlinson" wrote: Generally speaking macros are easy to defeat in terms of security. Why not use password protection. File - Save As - Tools - General Options - Password. Now the only wat to open the spreadsheet is with the password. -- HTH... Jim Thomlinson "mydogpeanut" wrote: only allows certain users to open a spreadsheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i write a macro | Excel Worksheet Functions | |||
| How do i write a Macro that does following | New Users to Excel | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| Q: how can I write this macro? | Excel Discussion (Misc queries) | |||
| Need help to write macro please | Excel Programming | |||
Linear Mode
