BobColorado
New Member
- Joined
- Jun 19, 2020
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
Recent had some assistance with text in a cell and shown using macros, Alt+F8 AddNote copies the properties of the text and color of background, allowing a larger size and comment triangle.
I tried to apply this to picture i size to fit with in the cell, and the cell box itself and both show runtime error pop up Visual Basic.
I know of another way to do this mouse over, and it has or seems to have plenty of steps to achieve the result. Can you magic wizards of Excel, help and show me the steps and the way?
this shows what i have in my document with the macro cover up to show indicators when printing.
Related, interest is to show the Red comment indicator when printing, and i have done this to my main document as it covers up the displayed indicator and shows up for printing, but i want to know if this can be added to or can more than one Macros be stacked together/added together to do different things? I am wondering now, if i use the Alt+F8 select AddNote, then want to (if i can) add the cover up indicator, can or how is this done as well.
I am a novice to the wizardly tricks using Excel.
Thank you for any and all help.
I tried to apply this to picture i size to fit with in the cell, and the cell box itself and both show runtime error pop up Visual Basic.
I know of another way to do this mouse over, and it has or seems to have plenty of steps to achieve the result. Can you magic wizards of Excel, help and show me the steps and the way?
Related, interest is to show the Red comment indicator when printing, and i have done this to my main document as it covers up the displayed indicator and shows up for printing, but i want to know if this can be added to or can more than one Macros be stacked together/added together to do different things? I am wondering now, if i use the Alt+F8 select AddNote, then want to (if i can) add the cover up indicator, can or how is this done as well.
I am a novice to the wizardly tricks using Excel.
Thank you for any and all help.