View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default Excel 2007 Shortcut do not work

hi, !

Recently upgraded to Excel 2007 via Office Enterprise 2007.
Converted one spreadsheet to the .xlsm format and created a desktop shortcut to replace the old one.
The spreadsheet is password protected.
When I double-click the shortcut, Excel will open but the spreadsheet does not.
If I then try to open from within Excel, the password prompt comes up and then access to the spreadsheet.
How do I get the shortcut to work properly?


Jim Rech posted this workaround (windows registry modification)...

HKCU\Software\Microsoft\Office\12.0\Excel\Security
- modify/add a DWord key named: ExcelBypassEncryptedMacroScan
set its value to 1 (one)

hth,
hector.