In Excel 2010, I'm trying to create a button which will allow for the ink feature to be turned on or off. I can obviously do it one way by recording a macro, but I'd like to know how both the on and off setting can be integrated into one button.
I'd also like to do the same thing with comments as well using the same principle.
Google "VBA Toggle Button" There are to many links out there to list them here.
I'm guessing the code if put on a command button would look something like this, except that this is to change the color of a field.
I don't have 2010 and don't know about turning ink off or on.
Please Login or Register to view this content.
Alan
Alan
Last edited by alansidman; 02-19-2011 at 10:56 PM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks