sbozicevic
New Member
- Joined
- Mar 13, 2007
- Messages
- 13
Hi there,
I have a number of buttons that I am using to show/hide columns. The macro does the exact same thing every time, so I'd like to call it from every button instead of having each button bound to its own macro.
The challenge I am having is to pass a variable which defines the column I am trying to show/hide in the macro call.
My macro is called: ShowHideColumn
When I assign the macro behavir to the button, I am trying to achieve this: ShowHideColumn('OrderColumn')
So that in the macro, i can use the variable to show / hide the proper column.
When I try to pass the ('0rderColumn') string into the macro, it gives me an error message that says: "Formula is too complex to be assigned to the object"
Any suggestions?
I have a number of buttons that I am using to show/hide columns. The macro does the exact same thing every time, so I'd like to call it from every button instead of having each button bound to its own macro.
The challenge I am having is to pass a variable which defines the column I am trying to show/hide in the macro call.
My macro is called: ShowHideColumn
When I assign the macro behavir to the button, I am trying to achieve this: ShowHideColumn('OrderColumn')
So that in the macro, i can use the variable to show / hide the proper column.
When I try to pass the ('0rderColumn') string into the macro, it gives me an error message that says: "Formula is too complex to be assigned to the object"
Any suggestions?