Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
While recording a macro I clicked on the relative reference icon to
switch to absolute referencing. Now I want to go back to relative but the icon is not visible on the toolbar!!!! How can I make it reappear? Thanks |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub ResetStopMacro()
Application.CommandBars("stop recording").Reset End Sub HTH, Bernie MS Excel MVP wrote in message ... While recording a macro I clicked on the relative reference icon to switch to absolute referencing. Now I want to go back to relative but the icon is not visible on the toolbar!!!! How can I make it reappear? Thanks |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having the same problem as the original post. I tried copying the VBA
lines wrote in the previouse response in VB Editor. I tried to run and it did not correct the problem. Am I doing something wrong? -- Thanks - K "Bernie Deitrick" wrote: Sub ResetStopMacro() Application.CommandBars("stop recording").Reset End Sub HTH, Bernie MS Excel MVP wrote in message ... While recording a macro I clicked on the relative reference icon to switch to absolute referencing. Now I want to go back to relative but the icon is not visible on the toolbar!!!! How can I make it reappear? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using icon sets with relative references | Excel Worksheet Functions | |||
Embed object icon missing text and image | Excel Discussion (Misc queries) | |||
Excel Missing Save as Tool Icon | Excel Discussion (Misc queries) | |||
What happens to the Relative Refererence icon? | Excel Discussion (Misc queries) | |||
relative reference button missing for recording macros | Excel Programming |