LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 42
Default Protecting an Excel 2007 workbook with a warning before opening

Morning all

We have upgraded to Office 2007 within our office, but not across the
company yet. There are a number of worksheets that I have created using the
new functions (e.g. SumIfs) that aren't available in earlier versions of
Excel, so that when other users open them in earlier versions it returns the
#Name? result in the cell and effectively buggers up my formulae.

Is there a way to have a warning pop up as someone is about to open the
workbook informing them that if they do not have Excel 2007 to abort and
contact me instead? I.e. have a proceed or cancel option before opening the
workbook, but not have to rely on Password protecting.

Thanks

Mike
 
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
Number add-in warning comes up when opening files m_ridzon Excel Discussion (Misc queries) 1 March 15th 07 05:12 PM
Excel (Office 2007 B2TR) -- Password Protecting A Sheet -- Character Limit ? Office2007B2TR_Tester_91311 Excel Discussion (Misc queries) 2 October 12th 06 07:08 PM
Macro warning (upon opening) Richard Excel Discussion (Misc queries) 4 February 18th 05 10:43 PM
Why do I get a warning when I try to save an Excel 2003 workbook. David Williams Excel Discussion (Misc queries) 0 January 11th 05 07:59 PM
Warning when I try to save an Excel 2003 workbook. digicast Excel Discussion (Misc queries) 0 January 11th 05 07:55 PM


All times are GMT +1. The time now is 05:22 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"