Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
These damn buttons....
I have a collection of form buttons on sheet. They are all assigned to the same sub(). In that sub() I obtain their name: Dim button_name As String: button_name = Application.Caller When I do a copy sheet (leftclick tab, move or copy, x create copy) everything is just fine EXCEPT the buttons have changed their names. Select Case button_name Case "Button 2" row_day = oMyWs.Range("row_day_1").row Case "Button 3" row_day = oMyWs.Range("row_day_2").row The above fails because "Button 2" is now "Button 1". There is no "Button 1" on the source page (probably having been deleted during development) What gives? Can I fix this or am I doomed. Thank you. Excel 2010 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When a sheet is copied, i want also that the Sub's whithin this sheet is copied to the new sheet | Excel Programming | |||
The column names (A,B,C, etc...) changed to numbers?????????? | Setting up and Configuration of Excel | |||
Duplicate names on copied worksheet | Links and Linking in Excel | |||
The columns names on my sheet have changed!! | Excel Discussion (Misc queries) | |||
names changed somehow | Excel Programming |