#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Global.xls


Hi...

Is there a way to "remove" global.xls ?

I had some macros in this book preveously, but they are now remove
from the global workbook. Still a get the message "Global.xls is close
for editing" everytime I open a new workbook ( while another is open ).

So I would appreciate any solution to this problem..


Hoj

--
hoj
-----------------------------------------------------------------------
hojo's Profile: http://www.excelforum.com/member.php...fo&userid=3008
View this thread: http://www.excelforum.com/showthread.php?threadid=52566

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Global.xls

Why don't you just delete the globals.xls file?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"hojo" wrote
in message
...

Hi...

Is there a way to "remove" global.xls ?

I had some macros in this book preveously, but they are now
removed
from the global workbook. Still a get the message "Global.xls
is closed
for editing" everytime I open a new workbook ( while another is
open ).

So I would appreciate any solution to this problem..


Hojo


--
hojo
------------------------------------------------------------------------
hojo's Profile:
http://www.excelforum.com/member.php...o&userid=30082
View this thread:
http://www.excelforum.com/showthread...hreadid=525666



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Global.xls


As this is a hidden macro book, I don't know where to find it...

--
hoj
-----------------------------------------------------------------------
hojo's Profile: http://www.excelforum.com/member.php...fo&userid=3008
View this thread: http://www.excelforum.com/showthread.php?threadid=52566

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default Global.xls

Go to the Window menu and choose Unhide. This will allow you to
unhide the workbook. Then go to the File menu, choose Properties,
then the General Tab. The 'Location' item will tell you where the
workbook is located.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"hojo" wrote
in message
...

As this is a hidden macro book, I don't know where to find
it....


--
hojo
------------------------------------------------------------------------
hojo's Profile:
http://www.excelforum.com/member.php...o&userid=30082
View this thread:
http://www.excelforum.com/showthread...hreadid=525666



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Global.xls


:)

Thanx......




Hoj

--
hoj
-----------------------------------------------------------------------
hojo's Profile: http://www.excelforum.com/member.php...fo&userid=3008
View this thread: http://www.excelforum.com/showthread.php?threadid=52566

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
global changes Eclaires Excel Worksheet Functions 2 March 17th 08 01:03 PM
Global Calculation ??? Cowtoon Excel Discussion (Misc queries) 4 October 20th 05 04:52 PM
Global Variables Ernst Guckel[_4_] Excel Programming 2 May 7th 05 11:10 PM
Global range name msa165 Excel Programming 4 April 15th 05 04:24 AM
Global variable Don[_11_] Excel Programming 1 October 28th 03 04:15 AM


All times are GMT +1. The time now is 12:20 PM.

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

About Us

"It's about Microsoft Excel"