| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to prevent pasting to every sheet in workbook
I have now solve this problem. For some reason the PasteSpecial method was pasting the data into the sheets as links i.e [Output.xls]data!D123 so that each time I pasted a new sheet all the sheets would update with the linked data. I have now amended my code to just paste values and formats and everything is working. Nigel *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent bypassing security by copy/pasting to new workbook | Excel Discussion (Misc queries) | |||
| prevent changes to cell references when copying and pasting | Excel Discussion (Misc queries) | |||
| Prevent users to use a workbook/sheet after a specified day | Excel Worksheet Functions | |||
| Is there a way to prevent pasting data into an Excel worksheet? | Excel Worksheet Functions | |||
| prevent Excel from pasting icon when it starts | Excel Discussion (Misc queries) | |||
![Nigel Brown[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
