RE: premenovanie sheetu makrom

From: Koci Michal (Michal_Koci@koba.sk)
Date: 11. 03. 2002, 12:58 CET


A co takto:

  Dim shPrem As Worksheet
  Set shPrem = Sheets(1)
  shPrem.Name = "Komponent"

alebo takto:

  Dim shPrem As Worksheet
  Set shPrem = ActiveSheet
  shPrem.Name = "Komponent"

Dufam ze som postacil ja :))

Mifko

> Potrebujem premenovat v exceli sheet na nazov "Komponent".
> 
> Z nazvu "List1" to ide takto:
>     Sheets("List1").Select
>     Sheets("List1").Name = "Komponent"
> Povodny nazov sa ale casto meni.
> 
> Da sa sheet premenovat bez zadavania povodneho nazvu?
> 
> Ak pouzijem:
>     ActiveSheets.Select
> tak to nejde :-( .



This archive was generated by hypermail 2.1.2 : 11. 03. 2002, 12:57 CET