Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

MOVING SHEETS BETWEEN WORKBOOKS

  Asked By: Lewis    Date: Feb 04    Category: MS Office    Views: 1186
  

If I move a sheet to a new workbook, the command and option buttons
will not work when the sheet is in the new workbook. Please will
someone help me resolve this

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Kaysah Mohammad     Answered On: Feb 04

if u put the macro in the module, u must copy the module too
if u put the macro in the sheet, it also being copied when u copied / move  sheet
if u put the macro in the workbook, u must copy the procedure too

 
Didn't find what you were looking for? Find more on MOVING SHEETS BETWEEN WORKBOOKS Or get search suggestion and latest updates.




Tagged: