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 the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
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 Question
Trying to open misbehaving XLSM file: eliminating macros as a cause?
Replies
4
Views
1K
EdNerd
E
D
  • Question Question
Can't get MailMerge to work through VBA
Replies
0
Views
286
DetroitJimBurke
D
A
  • Question Question
Date and Time shortcut not working
Replies
2
Views
1K
Alex Blakenburg
A
S
  • Question Question
Big, Multi-Step Macro for Efficiently Cutting Big Pieces Into Small Pieces
Replies
1
Views
510
Solon Aquila
S
Y
  • Question Question
Macro keyboard shortcut doesn't work
2
Replies
10
Views
2K
GWteB
GWteB

Forum statistics

Threads
1,224,599
Messages
6,179,831
Members
452,946
Latest member
JoseDavid

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