View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steven B Steven B is offline
external usenet poster
 
Posts: 14
Default Activecell select properties

Hello,

Not sure what your end goal looks like, but it sounds like you are
using the inputs to create some sort of report perhaps.

What if you set up your workbook as multi-sheet
Sheet 1 = inputs
Sheet 2 = hidden data
Sheet "New" = Sheet created by macro to display final report data
generated by macros in Sheet 1

You can still protect the book to prevent user modification, or
unprotect/reprotect the workbook using the macro as well.


Steven

On Jul 28, 4:13*pm, dgold82 wrote:
This is a variance on an earlier question of mine. I was trying to completely
hide the little border when selecting a cell. Doesn't look like you can do
this.

I was thinking that perhaps we can change the visible properties of it. I
saw a great addin from someone (can't remember who) that allows for an active
cell to be highlighted certain colors as you click around, but not the actual
select border. If I can make it white or transparent that could be a good
workaround for me.

My end goal was really to make a worksheet unselectable (inputs are radio
buttons) but I need it to be selectable for certain macros and hyperlinks to
work. I am trying to mimic the look of an unselectable worksheet.

Help would be most appreciated!