Macro Newbie... need help copying existing sheet and renaming it

**s0nginmyheart** · 10-08-2012, 01:52 PM

Hi all,

I am a newbie to using macros and I was wondering if I could get some assistance. I was looking at other threads with a similar request but the code seemed specific to their issue that when I tried to replicate it in Visual Basic I kept getting errors.

I have a Spreadsheet where in the main sheet (called "Home"), I would like to create a button (macro) that will allow me to copy a hidden page (titled: ActionPlan) and allow me to rename that sheet (example: ActionPlanOct2012) in the same workbook. From there, is it also possible to have a link created back in the "Home" sheet on a specific cell (ex: Cell G-14) to the newly created ActionPlanOct2012 sheet? I plan on hiding the sheet tabs at the bottom of the spreadsheet and only using hyperlinks to other pages in the "Home" sheet.

Any assistance is most appreciated. Thanks in advance.

**patel45** · 10-09-2012, 03:27 AM

attach a sample file for testing

**s0nginmyheart** · 10-09-2012, 11:25 AM

Thanks for taking a look! I hope my request is not too confusing. I made some notes in the spreadsheet.

**patel45** · 10-09-2012, 01:25 PM

I'm able to answer only to first question

Please Login or Register  to view this content.

**Norie** · 10-09-2012, 01:42 PM

Have a look at the attachment.

**s0nginmyheart** · 10-09-2012, 04:23 PM

Thank you. I just realized this, but is there also a way to create a "delete ActionPlan" button the same way there is an "add ActionPlan" button? "Delete ActionPlan" would need to delete the new ActionPlanOct2012 sheet and delete the hyperlink as well...

Also, when I click "add Action Plan" it automatically generates ActionPlanOct2012, but is there a way to prompt me what to name the new sheet? Because, when I click "add action plan" a 2nd time I get some kind of debug error... where as I may want one for Nov2012 or Dec2012.

Thanks in advance-