Shared file - macro error
 

*** · Insert or change charts, pictures, **objects**, or hyperlinks. ***

As Doc Holiday said, " I'm you huckleberry."

--
Regards,
Tom Ogilvy


steve wrote in message
...
Victor,

Without seeing your code, it's hard to say. But for starters - there are
a
lot of things that can't be done in a Shared file. Below is a copy from
the
Help file on Shared Workbooks. Check out Help for more info.

steve

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:

· Delete worksheets.
· Merge cells. You can view cells that were merged before you shared the
workbook.
· 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.

· Insert or delete blocks of cells. You can insert or delete entire rows
and
columns.
· Insert or change charts, pictures, objects, or hyperlinks.
· Use the drawing tools.
· 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.

· Save, view, or make changes to scenarios.
· Group or outline data.
· Insert automatic subtotals.
· Create data tables.
· Create PivotTables or change the layout of existing PivotTables.
· Make changes to dialog boxes or menus.
· 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.


"Victor R. Carrion" wrote in message
...
Hi all:

Please send also copy of the anwers to my E-mail.

I have a file with a macro, written in sheet2 and
module1, in which if the person press double clicks on
the cell, it appears a pull down menu to choose from.

It works fine until the file it is saved as "Shared".

The message that appears when running the macro when the
file is shared is:

"Unable to get the add property of the dropdowns class?

Please help me to correct this situation, in order to be
able to run the macro under the shared file condition.

Thanks for the help.

Victor

Code below

Sub AddDropDownPlatform(Target As Range)
Dim ddbox As DropDown
Dim VaPlatform As Variant
Dim i As Integer

VaPlatform = Array("COMMUNICATIONS", "MAINFRAME", "OPEN
SYSTEMS", "RISK", "S400", "SUN", "TANDEM", "")
With Target
Set ddbox = Sheet2.DropDowns.Add
(.Left, .Top, .Width, .Height)
End With
With ddbox
.OnAction = "DeleteBox"
For i = LBound(VaPlatform) To UBound(VaPlatform)
.AddItem VaPlatform(i)
Next i
End With
End Sub