View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Chuckles123[_87_] Chuckles123[_87_] is offline
external usenet poster
 
Posts: 1
Default NEXT LEVEL OF ScreenUpdating


I created two new files: DUMMY.xlS and DUMMY.xlA (I created a ver
simple macro for each -- merely a MsgBox); the spreadsheet view of eac
file is a "blank new worksheet".

Interesting Point #1: When opening each file without digita
signatures, the initial spreadsheet view is a grey screen with a pop-u
requesting Enable or Disable Macros; upon selecting one of these, th
horizontal and vertical cell division lines appear.

Interesting Point #2: My .xlA file with a digital signature (if no
stored in the 'AddIns' folder, I think there is zero distinctio
between .xlA files and .xlS files) containing 10 Modules has only
grey screen for a spreadsheet view, with the caption of 'Microsof
Excel' (as opposed to a file name) at the top of the grey screen.
Could digitally signing my .xlA file have caused the spreadsheet vie
to convert to a grey screen??? After testing, I have decided that th
answer is no.

It's like the spreadsheet view has been deleted from my macro file.
have no idea how I managed to do this.

Chuckles12

--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=38504