View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ronnie Ronnie is offline
external usenet poster
 
Posts: 53
Default how do I judge current document is a blank one?

blank document means that there is nothing to print
in other word, user can not see something. in excel, when user clicks the
file menu and select the print menu to print current document, if current
document is a blank document, then a dialog will be show up to tell user that
there is nothing to print.
it is a blank document i mean

thanks,
Ronnie Ren


"NickHK" wrote:

Ronnie,
Depends what you define as "blank".

What about pictures, formats, cell borders, validation, background, VBA
code, cell comments, document properties........

NickHK

"Ronnie" wrote in message
...
there should be a way to judge whether current document is a blank one or

not
but I can not find it
how can i do it?
any help will be appreciated?


thanks,
Ronnie Ren