Excel 2003 workbook name qualifier
have a function in a spreadsheet named Main_Sheet
I have a second worksheet open named additional_items which contains a button click
When the button is pushed I want to run a function in the Main_Sheet named MovedDatatoINITSheet
I get an error "Compile error Expected: line number or label or statement or end statement
Private Sub ProcessAdditionalButton_Click()
=Main_Sheet!MovedDatatoINITSheet
End Sub
In the main _sheet
Public Sub Add_additional_non_catalog_Items()
Code
end sub
|
