Changing a formula that is copied and pasted using vba with excel 2000

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have created a workbook where I write formulas using vba
to copy and paste into specific cells. I have tried to
change the formulas in a newly saved workbook. Although
the formula shows that I have changed it in the VBA
editor, when I run the program, the values that are
returned are from the original formulas in the original
workbook. After making the changes I have compiled and
saved. If anyone can help keep me sane I would appreciate
it. Thanks.
 
-----Original Message-----
Just a 'shot in the dark' but could the 'new' workbook have ben opened
in read only mode?


---
Message posted

.
Thanks for the reply. When I open the workbook I enable
Click to expand...
the macro's, and when I look at the properties it does not
show as read only. Is there somewhere else that I should
look? Tom.
 
-----Original Message-----
Just a 'shot in the dark' but could the 'new' workbook have ben opened
in read only mode?


---
Message posted

.
I found it. My fault, I had another procedure that was
Click to expand...
being called that I "forgot" about. Thanks for the
input. Sorry for the trouble. Tom.
 
Back
Top