Hi all,
I have a macro which is assigned to a button in Excel (custom toolbar).
By clicking that i get a form which is designed in VBA.
It is working fine, if i make any changes in excel and if i click that button
with out saving the changes , it is not showing me the form ,
If i save the changes and click on that it is showing the form.
I don't want to do like , whether it is saved or not, if click on the
button it has to show the form. What to do for that.
Do i have to change the code to save all the changes by programmatically and
call that form or any thing else more
Here another problem is that if i change data in cell and click on the any other cells
than it is working fine and if i stay in that cell the click on the button it is showing nothing
and in VBA editor it not working until i save the data or click on the any other cell.
Kindly help on this...
Thanks
This message was edited by jagadeesh on 2002-10-04 00:00
I have a macro which is assigned to a button in Excel (custom toolbar).
By clicking that i get a form which is designed in VBA.
It is working fine, if i make any changes in excel and if i click that button
with out saving the changes , it is not showing me the form ,
If i save the changes and click on that it is showing the form.
I don't want to do like , whether it is saved or not, if click on the
button it has to show the form. What to do for that.
Do i have to change the code to save all the changes by programmatically and
call that form or any thing else more
Here another problem is that if i change data in cell and click on the any other cells
than it is working fine and if i stay in that cell the click on the button it is showing nothing
and in VBA editor it not working until i save the data or click on the any other cell.
Kindly help on this...
Thanks
This message was edited by jagadeesh on 2002-10-04 00:00