Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel 2013 - Quick Question


  • Please log in to reply

#1
a-cat

a-cat

    Member

  • Member
  • PipPip
  • 95 posts

I was experimenting with two (2) macros unsuccessfully to re-name multiple worksheets in an Excel 2013 file.  I added Developer to my toolbar, pasted some code to VBE,  clicked Run and was disappointed.  To confirm, I know ZERO - - ZIP - - NADA about macros or VBE (just clicking around).  Thereafter, I simply re-named each individual worksheet and disabled the macro.

 

However, now when I open a NEW Excel file it is titled Book12, Book13, Book14, Book15, Book16 (versus Book1).  Why is this happening and/or where are these unsaved files?

Normally, a new workbook always opens as Book1 until the user saves it with a specific name & location but that's not happening.  How can I correct and/or go back to the default setting?

 

Any help or quick solution would be greatly appreciated!  :yes:


  • 0

Advertisements


#2
RKinner

RKinner

    Malware Expert

  • Expert
  • 19,888 posts
  • MVP

You probably messed up the default workbook.  I don't have 2013 Excel but usually you can just search for workbook and find the one in

/Applications/Microsoft Office 2013/Office/Startup/Excel 

or similar and remove it.

I would cut it and paste it to your desktop just in case it messes something up but usually it will regenerate a clean Workbook the next time you start Excel.


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP