Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Columns
Is is possible to put some kind of setting, looping vba macro, etc
that would prevent data from being pasted into a hidden column? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden Columns
A Worksheet_Change macro can be written to pick up on the pasting of
something to that column. What do you want to happen when something is pasted into that column? What if the data pasted encompasses more than just that one column? In that case, do you want action taken for just the data pasted into that one column or should the entire pasting be addressed? HTH Otto wrote in message ups.com... Is is possible to put some kind of setting, looping vba macro, etc that would prevent data from being pasted into a hidden column? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
How to keep hidden columns hidden using protection | Excel Discussion (Misc queries) |