object name

  1. U

    How can I retreave the name of the selected table?

    I have selected a cell within a table and I need to return name of that table's name. I am looking for somthing like: TableName = ActiveTable.name There are many creative ways to return lists of objects such as ActiveSheet.ListObjects but I only need to return the name of the active table...
  2. F

    Colour code object Names in Navigation Pane

    Using Access 2007, is there a way to colour code object names in the Navigation Pane in addition to the custom groupings? For example, within a certain group of objects named "Mapping" which includes queries and tables, I would like the objects relating to one set of data to be shaded green (or...
  3. D

    Deleting tab without using sheet name but object name

    I am looking for VBA code that will allow me to delete a sheet using its Object Name and not the sheet name. The reason I need this is I download a document on a monthly basis where the name of sheet1 is different each month. I know the first sheet is always sheet1 then the new file name in the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top