Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
security constraints when you a excel scripting macro?
I am thinking of formatting excel spreadsheet using the excel macro recording
option. My problem is these spreadsheets are going to be emailed out to various customers. Can you tell if I will have any security issues for the customers? I would like to keep the security set to high on these spreadsheets. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
security constraints when you a excel scripting macro?
You don't have to put the macro into the workboook that is getting formatted.
You can put the macro in another workbook. A macro can open other workbooks then format the other workbook and close them. If you have 10 workbooks in a folder a macro can open each workbook in a folder and format the workbook and then close the workbook. Another option is to put the macro into a Personal.xls workbook. The personal.xls workbook automatically opens everytime you use excel and macros in the personal.xls file are available to use at any time. So yo can put the formating macro in the personal.xls and use it to format other workbooks. The recorded macro will probably need some minor changes to work from antoerh workbook. "douglas" wrote: I am thinking of formatting excel spreadsheet using the excel macro recording option. My problem is these spreadsheets are going to be emailed out to various customers. Can you tell if I will have any security issues for the customers? I would like to keep the security set to high on these spreadsheets. Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
security constraints when you a excel scripting macro?
Security settings are in the hands of the customers so they are the ones who
will be dealing with your macros if you leave them in the workbook you email. Gord Dibben MS Excel MVP On Sat, 4 Apr 2009 09:42:01 -0700, douglas wrote: I am thinking of formatting excel spreadsheet using the excel macro recording option. My problem is these spreadsheets are going to be emailed out to various customers. Can you tell if I will have any security issues for the customers? I would like to keep the security set to high on these spreadsheets. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for counting within specific constraints | Excel Discussion (Misc queries) | |||
Avoid Outlook macro security for Excel bades macro | Excel Programming | |||
Macro needed to set macro security in Excel to minimum | Excel Programming | |||
macro for 4 constraints in autofilter | Excel Discussion (Misc queries) | |||
VB Scripting/Macro - Filling/Editing Worksheet References | New Users to Excel |