ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hidden Columns (https://www.excelbanter.com/excel-programming/383398-hidden-columns.html)

[email protected]

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


Otto Moehrbach

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





All times are GMT +1. The time now is 10:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com