L
Lynn
i have a custom column with values. Does anyone have a macro to delete
these values in the column?
these values in the column?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Aksel
No macro needed.
First check to see if there is a formula calculating values in the column.
Right click on the column and select "Customize Fields..." In the dialog
box that opens, set the Custom Attributes to "None" instead of "Formula"
Then ...
1. Show all tasks
2. Click on the column header
3. Hold down the CTRL+DEL (or Edit/Clear/Clear Contents)
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
First check to see if there is a formula calculating values in the column.
Right click on the column and select "Customize Fields..." In the dialog
box that opens, set the Custom Attributes to "None" instead of "Formula"
Then ...
1. Show all tasks
2. Click on the column header
3. Hold down the CTRL+DEL (or Edit/Clear/Clear Contents)
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:
http://www.msprojectblog.com
L
Lynn
No macro needed.
First check to see if there is a formula calculating values in the column..
Right click on the column and select "Customize Fields..." In the dialog
box that opens, set the Custom Attributes to "None" instead of "Formula"
Then ...
1. Show all tasks
2. Click on the column header
3. Hold down the CTRL+DEL (or Edit/Clear/Clear Contents)
--
If this post was helpful, please consider rating it.
Jim Aksel, MVP
Check out my blog for more information:http://www.msprojectblog.com
- Show quoted text -
hi, i have multiples custom columns and require a macro to delete
values in all these columns.
Do you have one?
R
Rob Schneider
Lynn,
better if you try making yourself. Try turning on macro recording then
do what you want to do. Take the macro that you 'write" with this
approach and turn it into exactly what you want. Done. And available
for you to fix, improve, and support.
--rms
www.rmschneider.com
better if you try making yourself. Try turning on macro recording then
do what you want to do. Take the macro that you 'write" with this
approach and turn it into exactly what you want. Done. And available
for you to fix, improve, and support.
--rms
www.rmschneider.com
L
Lynn
Lynn,
better if you try making yourself. Try turning on macro recording then
do what you want to do. Take the macro that you 'write" with this
approach and turn it into exactly what you want. Done. And available
for you to fix, improve, and support.
--rms
www.rmschneider.com
- Show quoted text -
SelectTaskColumn works for me if the column is visible.
if the column is not visible on the project entry table, what command
can i use to clear its contents?
R
Rob Schneider
AFAIK if the columns is not visible in a table, you cannot change the
contacts of data in that column with commands you enter via a keyboard.
You could write a macro in VBA that deletes "columns" or pretty much
anything else. You would launch the macro from a toolbar button, menu,
or similar.
--rms
www.rmschneider.com
contacts of data in that column with commands you enter via a keyboard.
You could write a macro in VBA that deletes "columns" or pretty much
anything else. You would launch the macro from a toolbar button, menu,
or similar.
--rms
www.rmschneider.com
L
Lynn
AFAIK if the columns is not visible in a table, you cannot change the
contacts of data in that column with commands you enter via a keyboard.
You could write a macro in VBA that deletes "columns" or pretty much
anything else. You would launch the macro from a toolbar button, menu,
or similar.
--rms
www.rmschneider.com
- Show quoted text -
this is my original request, to have a macro to delete contents of a
column.
any help on how to do this?
R
Rob Schneider
--rms
www.rmschneider.com
This is a repeat of previous advice: Turn on Macro Recording. Then
delete the contents of the column. Then turn off macro recoding. Look
at the macro. Modify to make it supportable/sustaintable (if required).
Attach it to a Toolbar button or a menu.
www.rmschneider.com
this is my original request, to have a macro to delete contents of a
column.
any help on how to do this?
This is a repeat of previous advice: Turn on Macro Recording. Then
delete the contents of the column. Then turn off macro recoding. Look
at the macro. Modify to make it supportable/sustaintable (if required).
Attach it to a Toolbar button or a menu.
L
Lynn
--rms
www.rmschneider.com
This is a repeat of previous advice: Turn on Macro Recording. Then
delete the contents of the column. Then turn off macro recoding. Look
at the macro. Modify to make it supportable/sustaintable (if required)..
Attach it to a Toolbar button or a menu.- Hide quoted text -
- Show quoted text -
if the column is not visible on the entry table, i cannot use Macro
recording to delete its contents.
How to do this?
R
Rob Schneider
--rms
www.rmschneider.com
Put it on. Record the macro. The remove it, then run the macro. The
macro does not need what's on the screen. It is working in the field
names defined in the macro.
You can read more about VBA macros in Rod Gill's book, or generically by
looking at VBA.
www.rmschneider.com
if the column is not visible on the entry table, i cannot use Macro
recording to delete its contents.
How to do this?
Put it on. Record the macro. The remove it, then run the macro. The
macro does not need what's on the screen. It is working in the field
names defined in the macro.
You can read more about VBA macros in Rod Gill's book, or generically by
looking at VBA.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.