Excel shared workbook question

[Awarmplace1]

Is it possible to run a macro or visual basic code in a shared workbook??????

 

[SkipVought]

Hey warm,

Here's what Help says about the limitations of shared workbooks. Bottom line: You CAN run macros
=======================================
Limitations of shared workbooks
Some features of Microsoft Excel are not available when you use a shared workbook. If you need to use these features, do so before you share the workbook, or remove the workbook from shared use. For more information, click .

In a shared workbook, you cannot do the following:

Cells
Merge cells. You can view cells that were merged before you shared the workbook.


Insert or delete blocks of cells. You can insert or delete entire rows and columns.
Worksheets, dialog boxes, and menus
Delete worksheets.


Make changes to dialog boxes or menus.
Conditional formats and data validation
Define or apply conditional formats. However, you can see the effects of conditional formats applied before you shared the workbook.


Set up or change data validation restrictions and messages. However, you can see the effects of restrictions and messages that were set up before you shared the workbook.
Objects, charts, pictures, and hyperlinks
Insert or change charts, pictures, objects, or hyperlinks.


Use the drawing tools.
Passwords
Assign a password to protect individual worksheets or the entire workbook. Protection that you applied before sharing the workbook remains in effect after you share the workbook.


Change or remove passwords. Passwords that you assigned before sharing the workbook remain in effect after you share the workbook.
Scenarios
Save, view, or make changes to scenarios.

Outlines, groups, and subtotals
Group or outline data.


Insert automatic subtotals.
Data tables and PivotTables
Create data tables.


Create PivotTables or change the layout of existing PivotTables.
Macros
Write, change, view, record, or assign macros. However, you can record operations in a shared workbook into a macro stored in another workbook that isn't shared. In a shared workbook, you can run macros that were created before you shared the workbook; although if you run a macro that includes an unavailable operation, the macro stops running when it reaches the unavailable operation.
Skip,
metzgsk@voughtaircraft.com

 

[Awarmplace1]

Thank you very much.....that helps!