Ctr-S?

[dompoma]

I thought that ctr-s would save my workbook, but instead it made a blue highlighter color box around a cell. What is this and how do I get rid of it?

[FDibbins]

I dont know what you actually hit, butr CTRL S Saves the active file with its current file name, location, and file format.

for more shortcuts see this link...
http://shortcutworld.com/en/win/Excel_2007.html#link_4

I would suggest you take a look at what you might have pressed instead of either CTRL and/or S

[alansidman]

I suspect that you have a macro in your spreadsheet that has over ridden the default Ctl +S for save. Click on Alt + F8 and look at the macros in your spreadsheet and see if one of them is linked to Ctl + S.

[Careless]

hi, if you want to save file shortcut , you should try use alt+f+s

[dompoma]

I suspect that you have a macro in your spreadsheet that has over ridden the default Ctl +S for save. Click on Alt + F8 and look at the macros in your spreadsheet and see if one of them is linked to Ctl + S.

That fixed the problem. Thanks a lot.

[dompoma]

hi, if you want to save file shortcut , you should try use alt+f+s

That would be helpful. How do you save a file shortcut?

[JosephP]

alt+f+s is another shortcut like ctrl+s to save the file :-)

[dompoma]

alt+f+s is another shortcut like ctrl+s to save the file :-)

Oh I see. Is there way to create a shortcut. For example, if I know that I am going to be inserting a ton of picture comments into a lot of cells, having a shortcut for that would open up the picture comment windows would save a ton of clicking and time. Thanks for the help.

[JosephP]

only if you record/create a macro to do what you need and assign it a shortcut key

[dompoma]

only if you record/create a macro to do what you need and assign it a shortcut key

I just learned how to create a simple macro, but i cant figure out how to create a macro that gets me to the step of chosing a picture to insert into a comment. Do you know how I could get a macro to do that? I tried recording it, but when I tried to run the macro, it only took me to the step of creating the comment, not the step of browsing my pictures, which is what I would like it to take me to.

[dompoma]

I just learned how to create a simple macro, but i cant figure out how to create a macro that gets me to the step of chosing a picture to insert into a comment. Do you know how I could get a macro to do that? I tried recording it, but when I tried to run the macro, it only took me to the step of creating the comment, not the step of browsing my pictures, which is what I would like it to take me to.

does anyone know how to do this?

[JosephP]

perhaps

Please Login or Register  to view this content.

[dompoma]

Sorry I am a total noob with macros. could you explain the steps I take after I copy the code. Alls I know is that alt-f11 takes me to the Microsoft visual basic for applications, but I am not sure what to do when I get there.

thanks for the help

[JosephP]

insert - new module
paste the code in
then back in the main excel window use alt+f8 to bring up the macros dialog and assign a shortcut key to the macro

[dompoma]

insert - new module
paste the code in
then back in the main excel window use alt+f8 to bring up the macros dialog and assign a shortcut key to the macro

thank you so much man. you just saved me a ridiculous amount of time. the only problem now is that the picture comments are all small. is there a way to make them all bigger?

[JosephP]

do you mean that the pictures are small within the comment or the comments themselves need to be bigger?

[dompoma]

I started a separate thread for resizing all of the comments and just solved it last night. Thanks again for all your help!