copy cells from a protected workbook to anouther

dantb · Apr 22nd, 2002, 06:41 PM

Hi all, Is there anyway to copy from one protected workbook to anouther? I copy the data,click my cmd button to open my other workbook, And somehow it does not remember the data. Thx Dan

Iain Lewis · Apr 23rd, 2002, 04:28 AM

Hi Dan,

Have you tried linking the cells ? ie in the destiniation cell type :

=[protectedbook]Sheet1!$A$1

Could you also explain a little more about the proection on the file ? As there must be a dozen different ways to protect a a file it could be any number of things. I you need to get the file un-protected then I should be able to do that for you.

Iain

dantb · Apr 23rd, 2002, 07:45 PM

Hi Iain, The problem with linking, is the information or collums neaded could change,and the original workbook will not be saved with the information entered. The protection I am using is the basic Protect "Sheet" (all checked), Protect "workbook" (windows only). I am trying to supply a "extra" workbook that If someone neaded to create a custom report, the can copy the rows and collums that they nead From my "Protected Workbook" and paste the information neaded in there own .xls file (Unprotected),where they can do what ever. Thx Dan

brettvba · Apr 23rd, 2002, 07:56 PM

open the workbook first do all that is needed first then copy the data.

dantb · Apr 23rd, 2002, 08:10 PM

Thx brettvba, It works fine. Just have to open the other workbook before I start doing my updates. Have a good one thx again Dan .

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 06:41 PM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Hi all, Is there anyway to copy from one protected workbook to anouther? I copy the data,click my cmd button to open my other workbook, And somehow it does not remember the data. Thx Dan

Apr 23rd, 2002, 04:28 AM	#2
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	Hi Dan, Have you tried linking the cells ? ie in the destiniation cell type : =[protectedbook]Sheet1!$A$1 Could you also explain a little more about the proection on the file ? As there must be a dozen different ways to protect a a file it could be any number of things. I you need to get the file un-protected then I should be able to do that for you. Iain

Apr 23rd, 2002, 07:45 PM	#3
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Hi Iain, The problem with linking, is the information or collums neaded could change,and the original workbook will not be saved with the information entered. The protection I am using is the basic Protect "Sheet" (all checked), Protect "workbook" (windows only). I am trying to supply a "extra" workbook that If someone neaded to create a custom report, the can copy the rows and collums that they nead From my "Protected Workbook" and paste the information neaded in there own .xls file (Unprotected),where they can do what ever. Thx Dan

Apr 23rd, 2002, 07:56 PM	#4
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	open the workbook first do all that is needed first then copy the data.

Apr 23rd, 2002, 08:10 PM	#5
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	Thx brettvba, It works fine. Just have to open the other workbook before I start doing my updates. Have a good one thx again Dan .