Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm problem when Worksheet is cloned
To All,
I have a Workbook with many worksheets, 1 sheet which is named "MASTER". On the MASTER worksheet I have a USER FORM containing 3 COMMAND Buttons. Each button launches a macro. My problem is that 1 of my macros clone's the Master worksheet 1-12 times (by design) and during the cloning process the USER FORM also gets cloned. This is not terrible, however, there are now Command Buttons on the cloned sheets UserForm that should be 'ghosted' and unavailable. When I clone the MASTER worksheet once I can successfully set: .Enabled = False When I clone multiple times, only the last clone is correctly set, all the other cloned copies have the buttons the same as MASTER's UserForm. What am I doing incorrectly? The following is the Code I run when the MASTER worksheets UserForm has the Monthly Projection Command Button selected: ''''''''''''''''''''''''''' Private Sub Monthly_Projection_Button_Click() Application.ScreenUpdating = True ' SET UserForm buttons to be 'ghosted' prior to Schedule Creation CreateButton.Enabled = False Monthly_Projection_Button.Enabled = False Application.ScreenUpdating = True MASTER.Hide If Not CREATE_YEAR_PROJECTION Then ' Projection was aborted ... Restore UserForm buttons CreateButton.Enabled = True Monthly_Projection_Button.Enabled = True End If End Sub ''''''''''''''''''''''''''' Any Help would be appreciated ... Thanks, JimP |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm problem when Worksheet is cloned
Took a while ... but problem solved ...
J.Pellechi *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform problem? | Excel Discussion (Misc queries) | |||
userform problem | Excel Discussion (Misc queries) | |||
SOme problem on VBA Userform | Excel Programming | |||
UserForm Problem | Excel Programming | |||
Userform Problem | Excel Programming |