If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
button properties
how to stop assigning macros to buttons by others ?
how can I edit macros which are hide ? |
#2
|
|||
|
|||
button properties
#1. Maybe you could protect the worksheet (tools|Protection|protect sheet)
#2. Don't got through tools|macro|macros dialog. Open the VBE (alt-f11 is one way) and just edit those macros directly. Narasimha wrote: how to stop assigning macros to buttons by others ? how can I edit macros which are hide ? -- Dave Peterson |
#3
|
|||
|
|||
button properties
thank you Dave , but
1) button is placed by Forms tool bar , even though work sheet is protected macros are assigning to button(by right click on button and assign macros) 2)macros are hide with " Private Sub ( ) " , in VBE editor also those hide macros are not visible to edit . "Dave Peterson" wrote: #1. Maybe you could protect the worksheet (tools|Protection|protect sheet) #2. Don't got through tools|macro|macros dialog. Open the VBE (alt-f11 is one way) and just edit those macros directly. Narasimha wrote: how to stop assigning macros to buttons by others ? how can I edit macros which are hide ? -- Dave Peterson |
#4
|
|||
|
|||
button properties
I used xl2003 and when I protected the worksheet, I couldn't rightclick on the
forms button placed on the worksheet. If I allowed the user to edit objects, then I could assign a different macro. So I didn't allow this. And those macros are not visible in the Tools|Macros|macro dialog, but they can be seen in the VBE. Maybe the workbook's project is protected and you have to provide a password to see them??????? Narasimha wrote: thank you Dave , but 1) button is placed by Forms tool bar , even though work sheet is protected macros are assigning to button(by right click on button and assign macros) 2)macros are hide with " Private Sub ( ) " , in VBE editor also those hide macros are not visible to edit . "Dave Peterson" wrote: #1. Maybe you could protect the worksheet (tools|Protection|protect sheet) #2. Don't got through tools|macro|macros dialog. Open the VBE (alt-f11 is one way) and just edit those macros directly. Narasimha wrote: how to stop assigning macros to buttons by others ? how can I edit macros which are hide ? -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
button properties
Now I got it . Thank you very much Dave .
"Dave Peterson" wrote: I used xl2003 and when I protected the worksheet, I couldn't rightclick on the forms button placed on the worksheet. If I allowed the user to edit objects, then I could assign a different macro. So I didn't allow this. And those macros are not visible in the Tools|Macros|macro dialog, but they can be seen in the VBE. Maybe the workbook's project is protected and you have to provide a password to see them??????? Narasimha wrote: thank you Dave , but 1) button is placed by Forms tool bar , even though work sheet is protected macros are assigning to button(by right click on button and assign macros) 2)macros are hide with " Private Sub ( ) " , in VBE editor also those hide macros are not visible to edit . "Dave Peterson" wrote: #1. Maybe you could protect the worksheet (tools|Protection|protect sheet) #2. Don't got through tools|macro|macros dialog. Open the VBE (alt-f11 is one way) and just edit those macros directly. Narasimha wrote: how to stop assigning macros to buttons by others ? how can I edit macros which are hide ? -- Dave Peterson -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|