Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 2nd, 2006, 09:55 PM
Authorized User
 
Join Date: Jul 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default Selected Cell Highlight

Can anyone tell me what can cause the highlight around a cell that is selected to not show? I have a workbook of sheets that are virtually identical, but one of the sheets is not showing the selected cell. I do have a lot of locked cells on the protected sheet, but the unselected cells are not highlighting. I have checked the protection to allow unlocked cells to be selected. The cells do actually select, but there just is no highlight to show they are selecte.

Thanks, Terry
 
Old December 3rd, 2006, 11:10 AM
Authorized User
 
Join Date: Jul 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I solved my own problem. To position the cursor, I was erroneously selecting a locked cell on the sheet from VBE, even though the sheet was protected, before giving control to the sheet. Apparently you can do that without any error appearing. After doing that, the highlight on a selected cell was hidden until I unprotected the sheet manually. Thanks for looking anyway.

Terry





Similar Threads
Thread Thread Starter Forum Replies Last Post
how to get text of a particular cell of selected r jjkk BOOK: ASP.NET AJAX Programmer's Reference : with ASP.NET 2.0 or ASP.NET 3.5 ISBN: 978-0-470-10998-4 0 January 22nd, 2008 07:39 AM
To highlight multiple selected values in listbox lily611 General .NET 7 August 20th, 2007 12:59 AM
How to highlight selected dropdown values. sheetm J2EE 0 June 5th, 2007 05:04 AM
Highlight Datagrid Cell derekl ASP.NET 1.0 and 1.1 Basics 1 July 28th, 2006 06:12 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.