L
Lisa
I have a workbook that will be used by several people. I need them to be
able to copy a worksheet and use the macros placed on there for the new
worksheet. I am finding that when I copy my first worksheet, and attempt to
run the macro on sheet2, it goes back to sheet1.
1 macro is written as follows:
Sub Shelving()
'
' Shelving Macro
'
'
ActiveWorkbook.CustomViews("Shelving").Show
End Sub
What do I need to change in order to have this work on the new sheet?
able to copy a worksheet and use the macros placed on there for the new
worksheet. I am finding that when I copy my first worksheet, and attempt to
run the macro on sheet2, it goes back to sheet1.
1 macro is written as follows:
Sub Shelving()
'
' Shelving Macro
'
'
ActiveWorkbook.CustomViews("Shelving").Show
End Sub
What do I need to change in order to have this work on the new sheet?