Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
sumatradc
 
Posts: n/a
Default CTRL-N will NOT open a new workbook in Excel

When user logs into Excel for first time, Book2 is the first workbook opened
(I don't know why it skips over Book1). When he attempts to create another
workbook by using the CTRL-N command, he gets the error message: "The Macro
'!CheckInstance' cannot be found". If it helps to know, he is only able to
create another workbook by using the New icon on the standard Toolbar. If he
tries by going to File-New... nothing happens.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default CTRL-N will NOT open a new workbook in Excel

He's opening a file that has stolen the ctrl-N keystroke.

Here are a couple of sites that explain how to troubleshoot startup problems:

Chip Pearson's:
http://www.cpearson.com/excel/StartupErrors.htm

Jan Karel Pieterse's:
http://www.jkp-ads.com/Articles/StartupProblems.htm

Essentially, you move all of the stuff out of XLStart and you turn off all the
addins under Tools|addins.

Then you start adding things back one at a time and testing each time to see if
the problem is fixed. When you add something back that causes the problem to
come back, you'll have to decide what to do with that addin.


===
As for the file|new not working, I'd try resetting the toolbar.

View|Toolbars|Customize|toolbars tab
select worksheet menu bar and click Reset

(It'll reset that whole toolbar, though.)

sumatradc wrote:

When user logs into Excel for first time, Book2 is the first workbook opened
(I don't know why it skips over Book1). When he attempts to create another
workbook by using the CTRL-N command, he gets the error message: "The Macro
'!CheckInstance' cannot be found". If it helps to know, he is only able to
create another workbook by using the New icon on the standard Toolbar. If he
tries by going to File-New... nothing happens.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
sumatradc
 
Posts: n/a
Default CTRL-N will NOT open a new workbook in Excel

PERFECT! It was something contained in the Add-in €śexpress wizard€ť. When I
disable this add in and start a new instance of Excel, it opens with book 1
and I can use the CTRL-N function. I have not used the express wizard to
date, so not sure I need it. Will sort that out on another day. Thanks for
your help with this issue. It makes a person who lives on the quick key very
happy.

"Dave Peterson" wrote:

He's opening a file that has stolen the ctrl-N keystroke.

Here are a couple of sites that explain how to troubleshoot startup problems:

Chip Pearson's:
http://www.cpearson.com/excel/StartupErrors.htm

Jan Karel Pieterse's:
http://www.jkp-ads.com/Articles/StartupProblems.htm

Essentially, you move all of the stuff out of XLStart and you turn off all the
addins under Tools|addins.

Then you start adding things back one at a time and testing each time to see if
the problem is fixed. When you add something back that causes the problem to
come back, you'll have to decide what to do with that addin.


===
As for the file|new not working, I'd try resetting the toolbar.

View|Toolbars|Customize|toolbars tab
select worksheet menu bar and click Reset

(It'll reset that whole toolbar, though.)

sumatradc wrote:

When user logs into Excel for first time, Book2 is the first workbook opened
(I don't know why it skips over Book1). When he attempts to create another
workbook by using the CTRL-N command, he gets the error message: "The Macro
'!CheckInstance' cannot be found". If it helps to know, he is only able to
create another workbook by using the New icon on the standard Toolbar. If he
tries by going to File-New... nothing happens.


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
in Excel how do you set a workbook to only open on the first work. Mark_J Excel Discussion (Misc queries) 9 February 1st 07 10:07 PM
selecting multiple sheet tabs and open another workbook Bannor Excel Discussion (Misc queries) 5 November 25th 05 02:38 AM
How do I open my excel workbook? ajojoel Excel Discussion (Misc queries) 5 April 21st 05 07:41 AM
Excel 2003 hangs when trying to locate a workbook to open Darren Hill via OfficeKB.com Excel Discussion (Misc queries) 1 March 24th 05 12:41 PM
i can't open excel workbook if it has a chart in it! Aidan Excel Discussion (Misc queries) 2 February 2nd 05 09:37 AM


All times are GMT +1. The time now is 09:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"