View Single Post
 
Old 06-02-2015, 09:09 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 32bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Hi Ronnie

There's more than likely better ways to do this but I think this will work for you. Try it out and see.

I've hidden the Blank sheet, it acts as a template, so you don't want it to get renamed and used. Alt + F8 will give you access to a macro which will add 10 blank sheets at a time. This macro can be run at any time and will always add another 10 blanks.

Let me know how it goes.
Attached Files
File Type: xlsm 5-12-15 Sample_2.xlsm (148.2 KB, 11 views)
Reply With Quote