Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-21-2022, 06:47 AM
Matt C's Avatar
Matt C Matt C is offline Remove toggle button "focus" (dotted inner border) using VBA Windows 10 Remove toggle button "focus" (dotted inner border) using VBA Office 97-2003
Advanced Beginner
Remove toggle button "focus" (dotted inner border) using VBA
 
Join Date: May 2021
Location: London, UK
Posts: 30
Matt C is on a distinguished road
Question Remove toggle button "focus" (dotted inner border) using VBA

Hi folks

I have a number of toggle buttons dotted around my spreadsheet - not part of a userform - and every time I click on them the "focus" remains on the button, i.e. a dotted inner border appears. I have to click away from the button (to remove the dotted border) before I can use various menu items which are otherwise greyed out.



It would appear that Excel 2003 does not include the "TakeFocusOnClick" option - which I think is what I need. Is there a way of removing the button focus another way using VBA?

Thanks, Matt
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How Do I Get Rid of This Dotted Border Around a Table in Word 2016? ARNK Word 3 11-02-2016 05:04 PM
Toggle Button takes focus and thus changes selection NobodysPerfect Word VBA 1 10-11-2014 04:20 AM
Remove toggle button "focus" (dotted inner border) using VBA Toggle Button Squibble Word VBA 2 06-11-2014 05:36 PM
Remove toggle button "focus" (dotted inner border) using VBA dotted lines under text -- how to remove? Straitsfan Word 1 11-11-2013 11:55 AM
Remove toggle button "focus" (dotted inner border) using VBA How to remove the dotted lines from a table of content? aleemu Word 2 06-21-2013 08:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft