button properties
 

how to stop assigning macros to buttons by others ?

how can I edit macros which are hide ?

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

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

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

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