Shortcut Keys wont work in 2007

asma410

asma410

New Member
Joined
Feb 1, 2005
Messages
35
Hello,
I am working with this spreadsheet in 2007 with some formulas & conditional formatting. The short key CTRL+SHIFT+A to update the spreadsheet does not work in this version. I have an earlier version of this file in 2003. When I have both the older & newer version files open, 'CTRL+SHIFT+A' works on both the files. I guess soemthing got lost during the conversion. Or could be a security issue. Not sure what to do. Any ideas?
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
Turns out that one of the modules was not copied over from the previous version. So its a VBA issue. Problem Solved :)
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Trying to open misbehaving XLSM file: eliminating macros as a cause?
Replies
4
Views
666
EdNerd
E
A
  • Question
Date and Time shortcut not working
Replies
2
Views
868
Alex Blakenburg
A
Y
  • Question
Macro keyboard shortcut doesn't work
2
Replies
10
Views
2K
GWteB
GWteB
T
  • Question
Macro Short Cut Keys (Ctrl Shift a-z) Not Working One-by-One
Replies
7
Views
6K
TRMMolloy
T
D
  • Question
Macros in 2011/6 xlsm disabled on another computer with 2007 despite trusted location & macros enabled
Replies
8
Views
2K
Jon Peltier
J

Forum statistics

Threads
1,215,059
Messages
6,122,918
Members
449,094
Latest member
teemeren

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top